AuditLogs

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

Back to Tables Index


Reference for AuditLogs table in Azure Monitor Logs.

Attribute Value
Category Azure Resources, Security
Basic Logs Eligible ✗ No (source)
Supports Transformations ✓ Yes (source)
Ingestion API Supported ✗ No
Lake-Only Ingestion ✓ Yes (source)
Azure Monitor Tables Reference View Documentation

Contents

Schema (31 columns)

Source: Azure Monitor documentation

Column Name Type Description
_BilledSize real The record size in bytes
_IsBillable string Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
AADOperationType string Type of the operation. Possible values are Add Update Delete and Other.
AADTenantId string ID of the ADD tenant
ActivityDateTime datetime Date and time the activity was performed in UTC.
ActivityDisplayName string Activity name or the operation name. Examples include Create User and Add member to group. For full list see Azure AD activity list.
AdditionalDetails dynamic Indicates additional details on the activity.
Category string Currently Audit is the only supported value.
CorrelationId string Optional GUID that's passed by the client. Can help correlate client-side operations with server-side operations and is useful when tracking logs that span services.
DurationMs long Property is not used and can be ignored.
Id string GUID that uniquely identifies the activity.
Identity string Identity from the token that was presented when the request was made. The identity can be a user account system account or service principal.
InitiatedBy dynamic User or app initiated the activity.
Level string Message type. This is currently always Informational.
Location string Location of the datacenter.
LoggedByService string Service that initiated the activity (For example: Self-service Password Management Core Directory B2C Invited Users Microsoft Identity Manager Privileged Identity Management.
OperationName string Name of the operation.
OperationVersion string REST API version that's requested by the client.
Resource string
ResourceGroup string
ResourceId string
ResourceProvider string
Result string Result of the activity. Possible values are: success failure timeout unknownFutureValue.
ResultDescription string Additional description of the result.
ResultReason string Describes cause of failure or timeout results.
ResultSignature string Property is not used and can be ignored.
ResultType string Result of the operation. Possible values are Success and Failure.
SourceSystem string The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
TargetResources dynamic Indicates information on which resource was changed due to the activity. Target Resource Type can be User Device Directory App Role Group Policy or Other.
TimeGenerated datetime Date and time the record was created.
Type string The name of the table

Schema References

Official Microsoft Learn documentation for field/column information:

Solutions (23)

This table is used by the following solutions:

Connectors (1)

This table is ingested by the following connectors:

Connector Selection Criteria
Microsoft Entra ID

Content Items Using This Table (107)

Analytic Rules (75)

In solution Business Email Compromise - Financial Fraud:

Analytic Rule Selection Criteria
Account Elevated to New Role OperationName == "Add member to role completed (PIM activation)"
Authentication Method Changed for Privileged Account ActivityDisplayName == "User registered security info"
LoggedByService == "Authentication Methods"
Privileged Account Permissions Changed OperationName has "Add eligible member"
User Added to Admin Role

In solution Cloud Identity Threat Protection Essentials:

Analytic Rule Selection Criteria
Multi-Factor Authentication Disabled for a User
New External User Granted Admin Role AADOperationType in "Assign,AssignEligibleRole"
ActivityDisplayName has_any "Add eligible member to role"
OperationName in "Invite external user,Redeem external user invite"
OperationName has "Invite external user"
OperationName has "Redeem external user invite"

In solution Microsoft Business Applications:

Analytic Rule Selection Criteria
Dataverse - Guest user exfiltration following Power Platform defense impairment OperationName == "Update user"
Dataverse - New non-interactive identity granted access OperationName == "Update application"
Power Apps - Bulk sharing of Power Apps to newly created guest users OperationName == "Invite external user"
Power Platform - Account added to privileged Microsoft Entra roles Identity != "MS-PIM"
Identity != "MS-PIM-Fairfax"

In solution Microsoft Entra ID:

Analytic Rule Selection Criteria
Account Created and Deleted in Short Timeframe OperationName in "Add user,Delete user"
Account created or deleted by non-approved user OperationName in "Add user,Delete user"
Admin promotion after Role Management Application Permission Grant AADOperationType == "Assign"
LoggedByService == "Core Directory"
OperationName == "Add app role assignment to service principal"
Authentication Methods Changed for Privileged Account
Azure RBAC (Elevate Access) ActivityDisplayName == "User has elevated their access to User Access Administrator for their Azure Resources"
Bulk Changes to Privileged Account Permissions
Conditional Access - A Conditional Access Device platforms condition has changed (the Device platforms condition can be spoofed) OperationName == "Update conditional access policy"
Conditional Access - A Conditional Access app exclusion has changed OperationName == "Update conditional access policy"
Conditional Access - A Conditional Access policy was deleted OperationName == "Delete conditional access policy"
Conditional Access - A Conditional Access policy was disabled OperationName == "Update conditional access policy"
Conditional Access - A Conditional Access policy was put into report-only mode OperationName == "Update conditional access policy"
Conditional Access - A Conditional Access policy was updated OperationName == "Update conditional access policy"
Conditional Access - A Conditional Access user/group/role exclusion has changed OperationName == "Update conditional access policy"
Conditional Access - A new Conditional Access policy was created OperationName == "Add conditional access policy"
Conditional Access - Dynamic Group Exclusion Changes OperationName == "Update group"
Credential added after admin consented to Application OperationName in "Add service principal credentials,Consent to application"
Cross-tenant Access Settings Organization Added OperationName has "Add a partner to cross-tenant access setting"
Cross-tenant Access Settings Organization Deleted OperationName has "Delete partner specific cross-tenant access setting"
Cross-tenant Access Settings Organization Inbound Collaboration Settings Changed OperationName has "Update a partner cross-tenant access setting"
Cross-tenant Access Settings Organization Inbound Direct Settings Changed OperationName has "Update a partner cross-tenant access setting"
Cross-tenant Access Settings Organization Outbound Collaboration Settings Changed OperationName has "Update a partner cross-tenant access setting"
Cross-tenant Access Settings Organization Outbound Direct Settings Changed OperationName has "Update a partner cross-tenant access setting"
External guest invitation followed by Microsoft Entra ID PowerShell signin OperationName == "Invite external user"
First access credential added to Application or Service Principal where no credential was present OperationName has "Certificates
secrets management"
Guest accounts added in Entra ID Groups other than the ones specified InitiatedBy has_any "CUSTOM DOMAIN NAME#"
OperationName in "Add member to group,Add owner to group"
Mail.Read Permissions Granted to Application ActivityDisplayName has "Consent to application"
ActivityDisplayName has_any "Add delegated permission grant"
Microsoft Entra ID Role Management Permission Grant LoggedByService == "Core Directory"
OperationName in "Add app role assignment to service principal,Add delegated permission grant"
Modified domain federation trust settings OperationName in "Set domain authentication,Set federation settings on domain"
Multiple admin membership removals from newly created admin.
NRT Authentication Methods Changed for VIP Users
NRT First access credential added to Application or Service Principal where no credential was present OperationName has_any "Add service principal,Certificates
secrets management"
NRT Modified domain federation trust settings OperationName in "Set domain authentication,Set federation settings on domain"
NRT New access credential added to Application or Service Principal OperationName has_any "Add service principal,Certificates
secrets management"
NRT PIM Elevation Request Rejected ActivityDisplayName == "Add member to role request denied (PIM activation)"
ResultReason != "RoleAssignmentExists"
NRT Privileged Role Assigned Outside PIM Identity != "MS-PIM"
Identity != "MS-PIM-Fairfax"
LoggedByService == "Core Directory"
OperationName == "Add member to role"
OperationName has "Add member to role outside of PIM"
NRT User added to Microsoft Entra ID Privileged Groups
New User Assigned to Privileged Role
New access credential added to Application or Service Principal OperationName has_any "Add service principal,Certificates
secrets management"
New onmicrosoft domain added to tenant AADOperationType == "Add"
OperationName in "Add unverified domain,Add verified domain"
PIM Elevation Request Rejected
Possible SignIn from Azure Backdoor OperationName == "Add unverified domain"
Privileged Role Assigned Outside PIM Identity != "MS-PIM"
Identity != "MS-PIM-Fairfax"
LoggedByService == "Core Directory"
OperationName == "Add member to role"
OperationName has "Add member to role outside of PIM"
Rare application consent OperationName has "Consent to application"
Suspicious Entra ID Joined Device Update OperationName == "Update device"
Suspicious Service Principal creation activity
Suspicious Sign In Followed by MFA Modification
Suspicious application consent for offline access LoggedByService == "Core Directory"
OperationName in "Add OAuth2PermissionGrant,Add delegated permission grant,Add service principal,Consent to application"
TargetResources has "offline"
Suspicious application consent similar to O365 Attack Toolkit LoggedByService == "Core Directory"
OperationName in "Add OAuth2PermissionGrant,Add delegated permission grant,Add service principal,Consent to application"
Suspicious application consent similar to PwnAuth LoggedByService == "Core Directory"
OperationName in "Add OAuth2PermissionGrant,Add delegated permission grant,Add service principal,Consent to application"
TargetResources has "offline"
User Assigned New Privileged Role AADOperationType in "Assign,AssignEligibleRole,CreateRequestGrantedRole,CreateRequestPermanentEligibleRole,CreateRequestPermanentGrantedRole"
ActivityDisplayName has_any "Add eligible member to role"
User added to Microsoft Entra ID Privileged Groups
full_access_as_app Granted To Application LoggedByService == "Core Directory"
OperationName == "Consent to application"
TargetResources has "full_access_as_app"

In solution SecurityThreatEssentialSolution:

Analytic Rule Selection Criteria
Threat Essentials - Multiple admin membership removals from newly created admin.
Threat Essentials - NRT User added to Microsoft Entra ID Privileged Groups LoggedByService == "Core Directory"
Threat Essentials - User Assigned Privileged Role AADOperationType in "Assign,AssignEligibleRole"
ActivityDisplayName has_any "Add eligible member to role"

In solution Threat Intelligence:

Analytic Rule Selection Criteria
TI Map URL Entity to AuditLogs

In solution Threat Intelligence (NEW):

Analytic Rule Selection Criteria
TI Map URL Entity to AuditLogs

In solution eDCRule:

Analytic Rule Selection Criteria
[Entra ID] Application Assigned Administrator Permissions Immediately After Obtaining Role Management Permissions AADOperationType == "Assign"
LoggedByService == "Core Directory"
OperationName == "Add app role assignment to service principal"
[Entra ID] Application Granted Administrative Permission to Assign Microsoft Entra ID Roles LoggedByService == "Core Directory"
OperationName in "Add app role assignment to service principal,Add delegated permission grant"
[Entra ID] Authentication Method Changed for Privileged Account
[Entra ID] Domain Federation Trust Settings Modified OperationName in "Set domain authentication,Set federation settings on domain"
[Entra ID] Mass Privileged Role Change Activity Detected ActivityDisplayName has_any "Add eligible member to role"
[Entra ID] Privilege Elevation Request Denied ActivityDisplayName == "Add member to role request denied (PIM activation)"
ResultReason != "RoleAssignmentExists"
[Entra ID] Privileged Role Assigned to User AADOperationType in "Assign,AssignEligibleRole,CreateRequestGrantedRole,CreateRequestPermanentEligibleRole,CreateRequestPermanentGrantedRole"
ActivityDisplayName has_any "Add eligible member to role"
[Entra ID] Privileged Role Assigned to a New User

Hunting Queries (17)

In solution Business Email Compromise - Financial Fraud:

Hunting Query Selection Criteria
Risky Sign-in with new MFA method
User detection added to privilege groups based in Watchlist ActivityDisplayName has_any "Add eligible member to role"
LoggedByService in "Core Directory,PIM"

In solution Cloud Identity Threat Protection Essentials:

Hunting Query Selection Criteria
Application Granted EWS Permissions OperationName has "Add app role assignment to service principal"
Interactive STS refresh token modifications OperationName has "StsRefreshTokenValidFrom"
User Granted Access and Grants Access to Other Users

In solution Hybrid Attack - Cloud & Identity:

Hunting Query Selection Criteria
Federated Identity Provider Added to Tenant
MFA Method Added on Risky Account
Secret Added to Dormant Service Principal OperationName == "Add service principal credentials"
Service principal credential change followed by novel SP sign-in
Suspicious OAuth App Consent Granting Sensitive Permissions OperationName in "Add app role assignment to service principal,Add delegated permission grant,Consent to application"
Suspicious sign-in followed by auth method or role change

In solution Microsoft Business Applications:

Hunting Query Selection Criteria
Power Apps - Anomalous bulk sharing of Power App to newly created guest users

In solution UEBA Essentials:

Hunting Query Selection Criteria
Anomalous Entra High-Privilege Role Modification OperationName == "Update user"
Anomalous High-Privileged Role Assignment OperationName == "Add member to role"

Standalone Content:

Hunting Query Selection Criteria
Conditional Access policy exclusion added OperationName == "Update conditional access policy"
Member or owner added to a role-assignable group within 24 hours of its creation OperationName in "Add group,Add member to group,Add owner to group"
Role-assignable group created OperationName == "Add group"

Workbooks (15)

In solution AzureSecurityBenchmark:

Workbook Selection Criteria
AzureSecurityBenchmark

In solution ContinuousDiagnostics&Mitigation:

Workbook Selection Criteria
ContinuousDiagnostics&Mitigation

In solution CybersecurityMaturityModelCertification(CMMC)2.0:

Workbook Selection Criteria
CybersecurityMaturityModelCertification_CMMCV2

In solution DPDP Compliance:

Workbook Selection Criteria
DPDPCompliance

In solution GDPR Compliance & Data Security:

Workbook Selection Criteria
GDPRComplianceAndDataSecurity

In solution Hybrid Attack - Cloud & Identity:

Workbook Selection Criteria
HybridAttack-Cloud&Identity

In solution Lumen Defender Threat Feed:

Workbook Selection Criteria
Lumen-Threat-Feed-Overview

In solution MaturityModelForEventLogManagementM2131:

Workbook Selection Criteria
MaturityModelForEventLogManagement_M2131

In solution Microsoft Entra ID:

Workbook Selection Criteria
AzureActiveDirectoryAuditLogs SourceSystem == "Azure AD"
ConditionalAccessSISM

In solution MicrosoftPurviewInsiderRiskManagement:

Workbook Selection Criteria
InsiderRiskManagement

In solution NISTSP80053:

Workbook Selection Criteria
NISTSP80053

In solution SOC Handbook: AdditionalDetails contains "fraud"

Workbook
InvestigationInsights

In solution SOX IT Compliance:

Workbook Selection Criteria
SOXITCompliance

In solution ZeroTrust(TIC3.0):

Workbook Selection Criteria
ZeroTrustTIC3

Resource Types

This table collects data from the following Azure resource types:

Selection Criteria Summary (48 criteria, 70 total references)

References by type: 0 connectors, 70 content items, 0 ASIM parsers, 0 other parsers.

Selection Criteria Connectors Content Items ASIM Parsers Other Parsers Total
OperationName == "Update conditional access policy" - 7 - - 7
OperationName has "Update a partner cross-tenant access setting" - 4 - - 4
OperationName in "Set domain authentication,Set federation settings on domain" - 3 - - 3
OperationName has_any "Add service principal,Certificates
secrets management"
- 3 - - 3
AADOperationType == "Assign"
LoggedByService == "Core Directory"
OperationName == "Add app role assignment to service principal"
- 2 - - 2
LoggedByService == "Core Directory"
OperationName in "Add app role assignment to service principal,Add delegated permission grant"
- 2 - - 2
ActivityDisplayName == "Add member to role request denied (PIM activation)"
ResultReason != "RoleAssignmentExists"
- 2 - - 2
AADOperationType in "Assign,AssignEligibleRole,CreateRequestGrantedRole,CreateRequestPermanentEligibleRole,CreateRequestPermanentGrantedRole"
ActivityDisplayName has_any "Add eligible member to role"
- 2 - - 2
OperationName == "Update user" - 2 - - 2
OperationName == "Invite external user" - 2 - - 2
OperationName in "Add user,Delete user" - 2 - - 2
LoggedByService == "Core Directory"
OperationName in "Add OAuth2PermissionGrant,Add delegated permission grant,Add service principal,Consent to application"
TargetResources has "offline"
- 2 - - 2
Identity != "MS-PIM"
Identity != "MS-PIM-Fairfax"
LoggedByService == "Core Directory"
OperationName == "Add member to role"
OperationName has "Add member to role outside of PIM"
- 2 - - 2
OperationName == "Add member to role completed (PIM activation)" - 1 - - 1
ActivityDisplayName == "User registered security info"
LoggedByService == "Authentication Methods"
- 1 - - 1
OperationName has "Add eligible member" - 1 - - 1
AADOperationType in "Assign,AssignEligibleRole"
ActivityDisplayName has_any "Add eligible member to role"
OperationName in "Invite external user,Redeem external user invite"
OperationName has "Invite external user"
OperationName has "Redeem external user invite"
- 1 - - 1
ActivityDisplayName has_any "Add eligible member to role" - 1 - - 1
OperationName == "Update application" - 1 - - 1
Identity != "MS-PIM"
Identity != "MS-PIM-Fairfax"
- 1 - - 1
ActivityDisplayName == "User has elevated their access to User Access Administrator for their Azure Resources" - 1 - - 1
OperationName == "Delete conditional access policy" - 1 - - 1
OperationName == "Add conditional access policy" - 1 - - 1
OperationName == "Update group" - 1 - - 1
OperationName in "Add service principal credentials,Consent to application" - 1 - - 1
OperationName has "Add a partner to cross-tenant access setting" - 1 - - 1
OperationName has "Delete partner specific cross-tenant access setting" - 1 - - 1
LoggedByService == "Core Directory"
OperationName == "Consent to application"
TargetResources has "full_access_as_app"
- 1 - - 1
OperationName has "Certificates
secrets management"
- 1 - - 1
InitiatedBy has_any "CUSTOM DOMAIN NAME#"
OperationName in "Add member to group,Add owner to group"
- 1 - - 1
ActivityDisplayName has "Consent to application"
ActivityDisplayName has_any "Add delegated permission grant"
- 1 - - 1
LoggedByService == "Core Directory"
OperationName in "Add OAuth2PermissionGrant,Add delegated permission grant,Add service principal,Consent to application"
- 1 - - 1
AADOperationType == "Add"
OperationName in "Add unverified domain,Add verified domain"
- 1 - - 1
OperationName == "Add unverified domain" - 1 - - 1
OperationName has "Consent to application" - 1 - - 1
OperationName == "Update device" - 1 - - 1
LoggedByService == "Core Directory" - 1 - - 1
AADOperationType in "Assign,AssignEligibleRole"
ActivityDisplayName has_any "Add eligible member to role"
- 1 - - 1
ActivityDisplayName has_any "Add eligible member to role"
LoggedByService in "Core Directory,PIM"
- 1 - - 1
OperationName has "Add app role assignment to service principal" - 1 - - 1
OperationName has "StsRefreshTokenValidFrom" - 1 - - 1
OperationName in "Add app role assignment to service principal,Add delegated permission grant,Consent to application" - 1 - - 1
OperationName == "Add service principal credentials" - 1 - - 1
OperationName == "Add member to role" - 1 - - 1
OperationName in "Add group,Add member to group,Add owner to group" - 1 - - 1
OperationName == "Add group" - 1 - - 1
SourceSystem == "Azure AD" - 1 - - 1
AdditionalDetails contains "fraud" - 1 - - 1
Total 0 70 0 0 70

AADOperationType

Value Connectors Content Items ASIM Parsers Other Parsers Total
Assign - 6 - - 6
AssignEligibleRole - 4 - - 4
CreateRequestGrantedRole - 2 - - 2
CreateRequestPermanentEligibleRole - 2 - - 2
CreateRequestPermanentGrantedRole - 2 - - 2
Add - 1 - - 1

ActivityDisplayName

Value Connectors Content Items ASIM Parsers Other Parsers Total
has_any Add eligible member to role - 6 - - 6
Add member to role request denied (PIM activation) - 2 - - 2
User registered security info - 1 - - 1
User has elevated their access to User Access Administrator for their Azure Resources - 1 - - 1
has Consent to application - 1 - - 1
has_any Add delegated permission grant - 1 - - 1

AdditionalDetails

Value Connectors Content Items ASIM Parsers Other Parsers Total
contains fraud - 1 - - 1

Identity

Value Connectors Content Items ASIM Parsers Other Parsers Total
!= MS-PIM - 3 - - 3
!= MS-PIM-Fairfax - 3 - - 3

InitiatedBy

Value Connectors Content Items ASIM Parsers Other Parsers Total
has_any CUSTOM DOMAIN NAME# - 1 - - 1

LoggedByService

Value Connectors Content Items ASIM Parsers Other Parsers Total
Core Directory - 12 - - 12
Authentication Methods - 1 - - 1
PIM - 1 - - 1

OperationName

Value Connectors Content Items ASIM Parsers Other Parsers Total
Update conditional access policy - 7 - - 7
Add delegated permission grant - 6 - - 6
Consent to application - 6 - - 6
Add app role assignment to service principal - 5 - - 5
has Update a partner cross-tenant access setting - 4 - - 4
Invite external user - 3 - - 3
Set domain authentication - 3 - - 3
Set federation settings on domain - 3 - - 3
Add OAuth2PermissionGrant - 3 - - 3
Add service principal - 3 - - 3
has_any Add service principal - 3 - - 3
has_any Certificates - 3 - - 3
Add member to role - 3 - - 3
Update user - 2 - - 2
Add user - 2 - - 2
Delete user - 2 - - 2
Add service principal credentials - 2 - - 2
Add member to group - 2 - - 2
Add owner to group - 2 - - 2
Add unverified domain - 2 - - 2
has Add member to role outside of PIM - 2 - - 2
Add group - 2 - - 2
Add member to role completed (PIM activation) - 1 - - 1
has Add eligible member - 1 - - 1
Redeem external user invite - 1 - - 1
has Invite external user - 1 - - 1
has Redeem external user invite - 1 - - 1
Update application - 1 - - 1
Delete conditional access policy - 1 - - 1
Add conditional access policy - 1 - - 1
Update group - 1 - - 1
has Add a partner to cross-tenant access setting - 1 - - 1
has Delete partner specific cross-tenant access setting - 1 - - 1
has Certificates - 1 - - 1
Add verified domain - 1 - - 1
has Consent to application - 1 - - 1
Update device - 1 - - 1
has Add app role assignment to service principal - 1 - - 1
has StsRefreshTokenValidFrom - 1 - - 1

ResultReason

Value Connectors Content Items ASIM Parsers Other Parsers Total
!= RoleAssignmentExists - 2 - - 2

SourceSystem

Value Connectors Content Items ASIM Parsers Other Parsers Total
Azure AD - 1 - - 1

TargetResources

Value Connectors Content Items ASIM Parsers Other Parsers Total
has offline - 2 - - 2
has full_access_as_app - 1 - - 1

Browse: 🏠 · Solutions · Connectors · Methods · Tables · Content · Parsers · ASIM Parsers · ASIM Products · Logic Apps · 📊

Back to Tables Index